package com.itheima.reggie.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.itheima.reggie.common.CustomException;
import com.itheima.reggie.entity.Category;
import com.itheima.reggie.entity.Dish;
import com.itheima.reggie.entity.Setmeal;
import com.itheima.reggie.mapper.CategoryMapper;
import com.itheima.reggie.service.CategoryService;
import com.itheima.reggie.service.DishService;
import com.itheima.reggie.service.SetmealService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class CategoryServiceImpl extends ServiceImpl<CategoryMapper,Category> implements CategoryService {

    @Autowired
    private DishService dishService;

    @Autowired
    private SetmealService setmealService;
    /**
     * 根据Id删除，删除之前需要进行判断
     * @param id
     */
    @Override
    public void remove(Long id) {
        //1、检查当前分类下是否有对应的菜品
        // SELECT COUNT(*) FROM `dish` WHERE category_id = 1397844263642378242
        // 结果大于0 ，则不能删除  代码结束 return R.error("当前分类下有菜品，不能删除")
        LambdaQueryWrapper<Dish> dishLqw = new LambdaQueryWrapper<>();
        dishLqw.eq(Dish::getCategoryId, id);
        int dishCount = dishService.count(dishLqw);
        if (dishCount > 0) {
            throw new CustomException("当前分类下关联了菜品，不能删除");
        }
        //2、检查当前分类下是否有对应的套餐
        // SELECT COUNT(*) FROM `setmeal` WHERE category_id= 1397844263642378242
        //结果大于0 ，则不能删除  代码结束 return R.error("当前分类下有套餐，不能删除")
        LambdaQueryWrapper<Setmeal> setmealLqw = new LambdaQueryWrapper<>();
        setmealLqw.eq(Setmeal::getCategoryId,id);
        int setmealCount = setmealService.count(setmealLqw);
        if (setmealCount > 0) {
            throw new CustomException("当前分类下关联了套餐，不能删除");
        }

        //3、可以删除,则调用mapper直接删除 categoryMapper.deleteById(id);
        super.removeById(id);
    }
}
